package org.jetnuke.modules.survey;

import java.util.Iterator;
import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.velocity.VelocityContext;
import org.jetnuke.common.ActionForward;
import org.jetnuke.common.IAction;
import org.jetnuke.common.IAdminInfo;
import org.jetnuke.common.IModuleInfo;
import org.jetnuke.common.IUserInfo;
import org.jetnuke.dao.DataAccessDriver;
import org.jetnuke.entities.Poll;
import org.jetnuke.entities.PollData;

public class Survey implements IAction {

	/*
	 * (non-Javadoc)
	 * 
	 * @see org.jetnuke.common.IAction#exec(javax.servlet.http.HttpServletRequest,
	 *      javax.servlet.http.HttpServletResponse,
	 *      org.apache.velocity.VelocityContext, org.jetnuke.common.IModuleInfo,
	 *      java.lang.String, org.jetnuke.common.IUserInfo,
	 *      org.jetnuke.common.IAdminInfo)
	 */
	public ActionForward exec(HttpServletRequest request,
			HttpServletResponse response, VelocityContext vc, IModuleInfo info,
			String op, IUserInfo ui, IAdminInfo ai) throws Exception {
		List ls = DataAccessDriver.getInst().newJPollDAO().selectAllNotArtIDOrderTimestampDesc();
			
			//pollPeer.doSelect(new Criteria().add(pollPeer.ARTID, 0,
				//Criteria.LESS_EQUAL).addDescendingOrderByColumn(
				//pollPeer.TIMESTAMP));
		Iterator it = ls.iterator();
		while (it.hasNext()) {
			Poll poll = (Poll) it.next();
			List options =DataAccessDriver.getInst().newPollDataDAO().selectByPollIDOrderVoteID(poll.getPOLLID()); 
			//	poll_dataPeer.doSelect(new Criteria().add(
				//	poll_dataPeer.POLLID, poll.getPOLLID()));
			Iterator it2 = options.iterator();
			int sum = 0;
			while (it2.hasNext()) {
				PollData dt = (PollData) it2.next();
				sum += dt.getOPTIONCOUNT();
			}
			poll.setTotalVotes(sum);
		}
		vc.put("polls", ls);
		return new ActionForward(op, info);
	}

}
